Error with straight-forward JDBC connection to Oracle

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Error with straight-forward JDBC connection to Oracle

Feedback Type: Problem

Product Area: Notes Client

Technical Area: Application Development

Platform: Windows

Release: 8.5.3

Reproducible: -Reproducibility-

Hello. If you have a minute, this is driving me over the edge. I've used ojdbc14.jar in the past and never really had any issues.

However, I am getting strange errors today with just some very basic code for testing.

I have tried ojdbc14.jar, ojdbc5.jar, ojdbc6.jar.

Pretty standard jdbc connection in a notes agent...

Class.forName("oracle.jdbc.driver.OracleDriver").newinstance;

Connection conn=DriveManaer.getConnection("jdbcracle:thin:@server.here.com:1521:TSTSID","username"."password");

........................

using ojdbc14.jar, I get NullPointerException at the conn line

using ojdbc5.jar or ojdbc6.jar, I get ArrayIndexoutOfBoundsException -1 at the conn line

----------------------------------------------------------------------

I have entered the IP instead of server.here.com and get the same results as above...

Connection conn=DriveManaer.getConnection("jdbcracle:thin:@IP.IP.IP.IP:1521:TSTSID","username"."password");

I have pinged server.here.com and IP and it sends back a response

---------------------------------------------------------------------------

I am also able to connect to a legacy SQL Server database on a different server using the same exact code except with the jtds driver (in the agent in Edit Project)...so I don't think it's a local issue...

Connection conn=DriverManager.getConnection("jdbc.jtds.sqlserver://IP.IP.IP.IP:1433/LMDB;TDS=8.0":username":"password")

----------------------------------------------------------------------------

does anybody see what could be wrong? thank you so much for your time.

Feedback number WEBB9P3KG8 created by ~Mary Dwoamar on 09/18/2014

Status: Open
Comments: